{{frmt=html}}{{lims=plcypridmaiduser}}{{name=Current Policy Usage}}{{lang=en}}{{cols=plcy=Policy%3Bmaid=Computer%user=User Name%3Bwhen=Started}}{{cach=hold:300}} {{qstr=sql;select policyName,policyID,userComputerName,userComputerID,userName,inuseWhen from KSInUse,KSUsers,KSPolicies where {{iftg=ptyp:plcy;inusePolicyID='{{item=pdax}}' AND }}{{iftg=ptyp:maid;inuseComputerID='{{item=pdac}}' AND }}{{iftg=ptyp:prid;inuseProgramID='{{item=pdax}}' AND }}{{iftg=ptyp:user;userName='{{item=pdac}}' AND }}inuseUserID=userID AND inusePolicyID=policyID order by {{iftg=sort:maid;userComputerName, }}{{iftg=sort:user;userName, }}{{iftg=sort:when;inuseWhen, }}policyName}} {{tmpl=styl; }} Current Policy Usage{{ifne=pnam; ({{item=pnam}})}} {{ifeq=fram;{{tmpl=btop}}
{{tmpl=ntop}}
{{tmpl=ftop}} {{tmpl=rtop}} }}
Current Policy Usage{{ifne=pnam; ({{item=pnam}})}}{{ifne=icnc;  }}
 
{{list=sqls; }}
Policy{{iftg=sort:plcy;  }} Computer{{iftg=sort:maid;  }} User{{iftg=sort:user;  }} Started{{iftg=sort:when;  }}
  {{item=t001}}   {{item=t003}}   {{item=t005}} {{item=t006}}
 
{{ifeq=fram;{{tmpl=rbot}} {{tmpl=fbot}}
Report generated {{item=time}}. All times are GMT{{item=gmto}}. {{item=admn}} ({{item=rtym}})
{{tmpl=bbot}}}}